﻿CREATE TABLE [ODExtensibility].[FeatureProperty] (
    [FeatureID]      INT                 NOT NULL,
    [PropertyID]     INT                 NOT NULL,
    [HierarchyCode]  [sys].[hierarchyid] NOT NULL,
    [HierarchyLevel] AS                  ([HierarchyCode].[GetLevel]()),
    [PropertyValue]  VARCHAR (550)       NOT NULL,
    [PropertyUnitID] INT                 NOT NULL,
    [TimeStamp]      DATETIME            NOT NULL
);

